<?php 

// ----------------------------- Field Spec settings are as below:	
//$fieldspec['<column>'] ['show'] = {'0' = notshown, '1' = show readonly, 'L' = show, use list (manual join), E = editable;
//$fieldspec['<column>'] ['key'] = {1 = key field, 0 of not (or dont include)};
//$fieldspec['<column>'] ['select'] = {'T' = text, 'D' = dropdown select, 'C' = checkbox (for 1 or 0 boolean), 'R' = radiogroup, 'A' = textarea, 'DT' = calendar for date-time};
//$fieldspec['<column>'] ['filter'] = {1 if value is filtered for, 0 or undefined if not};	
//$fieldspec['<column>'] ['add'] = {1 = include value as input in add box, 0 or undefined = do not };
//$fieldspec['<column>'] ['size'] = size of input field, or columns (cols) for textarea;
//$fieldspec['<column>'] ['rows'] = rows of textarea or listbox (future);
//$fieldspec['<column>'] ['headname'] = {Name to show on column heading or input heading};
//$fieldspec['<column>'] ['keyvalue'] = {array column to use for key in drop-down lists} ;
//For lists, Not needed if columns 'keyvalue' and 'showvalue' are used in array, no need to define these specs;
//$fieldspec['<column>'] ['showvalue'] = {array column to use for shown value in drop-down lists};
//$fieldspec['<column>'] ['rawformat']	= additional html to include inside the input field;
//$fieldspec['<column>'] ['image']	= image file name of image to associate with control (implemetned for calendar);
//$fieldspec['<column>'] ['showdateformat'] = format string for inital display of shown date, using php date formatters;
//$fieldspec['<column>'] ['cal'] ['ifFormat'] = format string of date from database (or whatever) for input to calendar, js date formatters;
//$fieldspec['<column>'] ['cal'] ['align'] = {'T1' Shows calendar above imput control (default), 'B1' shows it below controls};
//$fieldspec['<column>'] ['cal'] ['showsTime'] = {true = show time in calendar below date, false (Default) = show and use calendar for dates only};
//$fieldspec['<column>'] ['cal'] ['singleClick'] = {true = (Default) open calendar with single click, false = double click for calendar};
//$fieldspec['<column>'] ['allowhtml'] = {true:  do not escape html (to allow images, etc), false (or unset by default) escapes using htmlspecialchars)};
//$fieldspec['<column>']['source'] = table name for source table, will be appended to filters to resolve ambiguies with multiple tables


//---Note - for autoheadings, rows will be arranged in the order of these definition secitons for each column
	
if(($PAGETYPE == 'LIST') OR ($PAGETYPE == 'FORM') ){

}

//column settings for customerNumber
$fieldspec['customerNumber'] ['key'] = 1;
$fieldspec['customerNumber'] ['size'] = 20;
$fieldspec['customerNumber'] ['rows'] = 1;

//column settings for customerName
$fieldspec['customerName'] ['show'] = 'E';
$fieldspec['customerName'] ['select'] = 'T';
$fieldspec['customerName'] ['size'] = 20;
$fieldspec['customerName'] ['rows'] = 1;
$fieldspec['customerName'] ['add'] = 1;

//column settings for contactLastName
$fieldspec['contactLastName'] ['show'] = 'E';
$fieldspec['contactLastName'] ['select'] = 'T';
$fieldspec['contactLastName'] ['size'] = 20;
$fieldspec['contactLastName'] ['rows'] = 1;
$fieldspec['contactLastName'] ['add'] = 1;
$fieldspec['contactLastName'] ['key'] = 1;

//column settings for contactFirstName
$fieldspec['contactFirstName'] ['show'] = 'E';
$fieldspec['contactFirstName'] ['select'] = 'T';
$fieldspec['contactFirstName'] ['size'] = 20;
$fieldspec['contactFirstName'] ['rows'] = 1;
$fieldspec['contactFirstName'] ['add'] = 1;

//column settings for phone
$fieldspec['phone'] ['show'] = 'E';
$fieldspec['phone'] ['select'] = 'T';
$fieldspec['phone'] ['size'] = 20;
$fieldspec['phone'] ['rows'] = 1;
$fieldspec['phone'] ['add'] = 1;

//column settings for addressLine1
$fieldspec['addressLine1'] ['show'] = 'E';
$fieldspec['addressLine1'] ['select'] = 'T';
$fieldspec['addressLine1'] ['size'] = 20;
$fieldspec['addressLine1'] ['rows'] = 1;

//column settings for addressLine2
$fieldspec['addressLine2'] ['show'] = 'E';
$fieldspec['addressLine2'] ['select'] = 'T';
$fieldspec['addressLine2'] ['size'] = 20;
$fieldspec['addressLine2'] ['rows'] = 1;

//column settings for city
$fieldspec['city'] ['show'] = 'E';
$fieldspec['city'] ['select'] = 'T';
$fieldspec['city'] ['size'] = 20;
$fieldspec['city'] ['rows'] = 1;

//column settings for state
$fieldspec['state'] ['show'] = 'E';
$fieldspec['state'] ['select'] = 'T';
$fieldspec['state'] ['size'] = 20;
$fieldspec['state'] ['rows'] = 1;

//column settings for postalCode
$fieldspec['postalCode'] ['show'] = 'E';
$fieldspec['postalCode'] ['select'] = 'T';
$fieldspec['postalCode'] ['size'] = 20;
$fieldspec['postalCode'] ['rows'] = 1;

//column settings for country
$fieldspec['country'] ['show'] = 'E';
$fieldspec['country'] ['select'] = 'T';
$fieldspec['country'] ['size'] = 20;
$fieldspec['country'] ['rows'] = 1;

//column settings for salesRepEmployeeNumber
$fieldspec['salesRepEmployeeNumber'] ['show'] = 'E';
$fieldspec['salesRepEmployeeNumber'] ['select'] = 'T';
$fieldspec['salesRepEmployeeNumber'] ['size'] = 20;
$fieldspec['salesRepEmployeeNumber'] ['rows'] = 1;

//column settings for creditLimit
$fieldspec['creditLimit'] ['show'] = 'E';
$fieldspec['creditLimit'] ['select'] = 'T';
$fieldspec['creditLimit'] ['size'] = 20;
$fieldspec['creditLimit'] ['rows'] = 1;

?>